Overview

Dataset info

Number of variables181
Number of observations555
Missing cells67353 (67.0%)
Duplicate rows0 (0.0%)
Total size in memory756.0 KiB
Average record size in memory1.4 KiB

Variables types

Numeric30
Categorical21
Boolean14
Date0
URL0
Text (Unique)1
Rejected115
Unsupported0

Warnings

coligada_mais_antiga_ativa has 493 (88.8%) missing values Missing
coligada_mais_antiga_baixada has constant value "nan" Rejected
coligada_mais_nova_ativa has 493 (88.8%) missing values Missing
coligada_mais_nova_baixada has constant value "nan" Rejected
de_faixa_faturamento_estimado has 25 (4.5%) missing values Missing
de_faixa_faturamento_estimado_grupo has 25 (4.5%) missing values Missing
de_indicador_telefone has constant value "BOA" Rejected
de_saude_rescencia has 11 (2.0%) missing values Missing
de_saude_tributaria has 11 (2.0%) missing values Missing
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
dt_situacao has a high cardinality: 416 distinct values Warning
empsetorcensitariofaixarendapopulacao has 150 (27.0%) missing values Missing
faturamento_est_coligados has 493 (88.8%) missing values Missing
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.97987) Rejected
fl_epp has constant value "False" Rejected
fl_ltda has constant value "False" Rejected
fl_optante_simei has 101 (18.2%) missing values Missing
fl_optante_simples has 101 (18.2%) missing values Missing
fl_simples_irregular has constant value "False" Rejected
fl_spa has constant value "False" Rejected
fl_st_especial has constant value "False" Rejected
grau_instrucao_macro_analfabeto has constant value "nan" Rejected
grau_instrucao_macro_desconhecido has constant value "nan" Rejected
grau_instrucao_macro_escolaridade_fundamental has 530 (95.5%) missing values Missing
grau_instrucao_macro_escolaridade_media has 469 (84.5%) missing values Missing
grau_instrucao_macro_escolaridade_superior has 532 (95.9%) missing values Missing
idade_acima_de_58 is highly correlated with grau_instrucao_macro_escolaridade_fundamental (ρ = 0.91736) Rejected
idade_ate_18 has constant value "1.0" Rejected
idade_de_19_a_23 is highly correlated with idade_acima_de_58 (ρ = 0.94324) Rejected
idade_de_24_a_28 has 509 (91.7%) missing values Missing
idade_de_29_a_33 is highly correlated with grau_instrucao_macro_escolaridade_media (ρ = 0.92706) Rejected
idade_de_34_a_38 has 513 (92.4%) missing values Missing
idade_de_39_a_43 has 523 (94.2%) missing values Missing
idade_de_44_a_48 has 534 (96.2%) missing values Missing
idade_de_49_a_53 is highly correlated with idade_de_29_a_33 (ρ = 0.94905) Rejected
idade_de_54_a_58 is highly correlated with idade_de_34_a_38 (ρ = 0.97795) Rejected
idade_maxima_coligadas is highly correlated with coligada_mais_antiga_ativa (ρ = 1) Rejected
idade_maxima_socios has 193 (34.8%) missing values Missing
idade_media_coligadas has 492 (88.6%) missing values Missing
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 1) Rejected
idade_media_coligadas_baixadas has constant value "nan" Rejected
idade_media_socios is highly correlated with idade_maxima_socios (ρ = 0.96634) Rejected
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 1) Rejected
idade_minima_socios is highly correlated with idade_media_socios (ρ = 0.96723) Rejected
max_faturamento_est_coligados is highly correlated with faturamento_est_coligados_gp (ρ = 0.97533) Rejected
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.92088) Rejected
max_filiais_coligados has 540 (97.3%) missing values Missing
max_funcionarios_coligados_gp is highly correlated with max_faturamento_est_coligados_gp (ρ = 0.99882) Rejected
max_meses_servicos has 454 (81.8%) missing values Missing
max_meses_servicos_all has 424 (76.4%) missing values Missing
max_vl_folha_coligados is highly correlated with max_faturamento_est_coligados (ρ = 0.94328) Rejected
max_vl_folha_coligados_gp is highly correlated with max_funcionarios_coligados_gp (ρ = 0.98304) Rejected
media_faturamento_est_coligados is highly correlated with max_funcionarios_coligados_gp (ρ = 0.946) Rejected
media_faturamento_est_coligados_gp has 493 (88.8%) missing values Missing
media_filiais_coligados is highly correlated with max_filiais_coligados (ρ = 0.98482) Rejected
media_funcionarios_coligados_gp is highly correlated with media_filiais_coligados (ρ = 0.92902) Rejected
media_meses_servicos has 454 (81.8%) missing values Missing
media_meses_servicos_all is highly correlated with max_meses_servicos_all (ρ = 0.96516) Rejected
media_vl_folha_coligados is highly correlated with media_faturamento_est_coligados (ρ = 0.90233) Rejected
media_vl_folha_coligados_gp is highly correlated with media_funcionarios_coligados_gp (ρ = 0.99564) Rejected
meses_ultima_contratacaco has 424 (76.4%) missing values Missing
min_faturamento_est_coligados is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.94011) Rejected
min_faturamento_est_coligados_gp is highly correlated with min_faturamento_est_coligados (ρ = 0.98577) Rejected
min_filiais_coligados is highly correlated with media_vl_folha_coligados_gp (ρ = 0.91131) Rejected
min_funcionarios_coligados_gp is highly correlated with min_faturamento_est_coligados_gp (ρ = 0.99747) Rejected
min_meses_servicos has 454 (81.8%) missing values Missing
min_meses_servicos_all has 424 (76.4%) missing values Missing
min_vl_folha_coligados is highly correlated with min_faturamento_est_coligados (ρ = 0.91156) Rejected
min_vl_folha_coligados_gp is highly correlated with min_funcionarios_coligados_gp (ρ = 0.99979) Rejected
nm_meso_regiao has 64 (11.5%) missing values Missing
nm_micro_regiao has a high cardinality: 67 distinct values Warning
nm_micro_regiao has 64 (11.5%) missing values Missing
nu_meses_rescencia has 47 (8.5%) missing values Missing
percent_func_genero_fem has 22 (4.0%) zeros Zeros
percent_func_genero_fem has 454 (81.8%) missing values Missing
percent_func_genero_masc has 32 (5.8%) zeros Zeros
percent_func_genero_masc has 454 (81.8%) missing values Missing
qt_admitidos has 424 (76.4%) missing values Missing
qt_admitidos_12meses has 89 (16.0%) zeros Zeros
qt_admitidos_12meses has 424 (76.4%) missing values Missing
qt_alteracao_socio_180d has constant value "nan" Rejected
qt_alteracao_socio_365d has constant value "nan" Rejected
qt_alteracao_socio_90d has constant value "nan" Rejected
qt_alteracao_socio_total has constant value "nan" Rejected
qt_art is highly correlated with qt_admitidos (ρ = 1) Rejected
qt_coligadas is highly correlated with min_filiais_coligados (ρ = 0.96825) Rejected
qt_coligados is highly correlated with qt_coligadas (ρ = 0.99748) Rejected
qt_coligados_agropecuaria has 492 (88.6%) missing values Missing
qt_coligados_atividade_alto has constant value "0.0" Rejected
qt_coligados_atividade_baixo has constant value "0.0" Rejected
qt_coligados_atividade_inativo has constant value "0.0" Rejected
qt_coligados_atividade_medio has constant value "0.0" Rejected
qt_coligados_atividade_mt_baixo has constant value "0.0" Rejected
qt_coligados_ativo has 492 (88.6%) missing values Missing
qt_coligados_baixada has constant value "0.0" Rejected
qt_coligados_ccivil is highly correlated with qt_art (ρ = 1) Rejected
qt_coligados_centro is highly correlated with qt_coligadas (ρ = 0.91428) Rejected
qt_coligados_comercio has 21 (3.8%) zeros Zeros
qt_coligados_comercio has 492 (88.6%) missing values Missing
qt_coligados_epp has constant value "0.0" Rejected
qt_coligados_exterior has constant value "0.0" Rejected
qt_coligados_inapta has 492 (88.6%) missing values Missing
qt_coligados_industria is highly correlated with qt_coligados_ccivil (ρ = 0.90112) Rejected
qt_coligados_ltda is highly correlated with qt_coligados_centro (ρ = 1) Rejected
qt_coligados_matriz is highly correlated with qt_coligados (ρ = 0.99154) Rejected
qt_coligados_me has constant value "0.0" Rejected
qt_coligados_mei has constant value "0.0" Rejected
qt_coligados_nordeste is highly correlated with qt_coligados_ativo (ρ = 0.90069) Rejected
qt_coligados_norte is highly correlated with qt_art (ρ = 1) Rejected
qt_coligados_nula has constant value "0.0" Rejected
qt_coligados_sa is highly correlated with qt_coligados_industria (ρ = 0.98024) Rejected
qt_coligados_serviço is highly correlated with max_vl_folha_coligados (ρ = 0.91346) Rejected
qt_coligados_sudeste is highly correlated with qt_coligados_ltda (ρ = 0.94436) Rejected
qt_coligados_sul has constant value "0.0" Rejected
qt_coligados_suspensa has constant value "0.0" Rejected
qt_desligados is highly correlated with qt_art (ρ = 1) Rejected
qt_desligados_12meses is highly correlated with qt_art (ρ = 1) Rejected
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 0.99994) Rejected
qt_filiais is highly correlated with qt_coligados_sa (ρ = 0.9758) Rejected
qt_funcionarios is highly correlated with idade_de_49_a_53 (ρ = 0.93264) Rejected
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.9758) Rejected
qt_funcionarios_24meses is highly correlated with qt_admitidos (ρ = 0.922) Rejected
qt_funcionarios_coligados is highly correlated with qt_filiais (ρ = 0.94954) Rejected
qt_funcionarios_coligados_gp is highly correlated with qt_funcionarios_coligados (ρ = 0.97194) Rejected
qt_funcionarios_grupo is highly correlated with qt_funcionarios_coligados_gp (ρ = 0.91578) Rejected
qt_ramos_coligados is highly correlated with qt_funcionarios_grupo (ρ = 0.96688) Rejected
qt_regioes_coligados is highly correlated with qt_coligadas (ρ = 0.91428) Rejected
qt_socios has 147 (26.5%) missing values Missing
qt_socios_coligados is highly correlated with qt_coligados_ativo (ρ = 0.98249) Rejected
qt_socios_feminino has 365 (65.8%) missing values Missing
qt_socios_masculino is highly correlated with qt_art (ρ = 1) Rejected
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 1) Rejected
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 1) Rejected
qt_socios_pj has 147 (26.5%) missing values Missing
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 1) Rejected
qt_socios_pj_baixados has constant value "nan" Rejected
qt_socios_pj_inaptos has constant value "nan" Rejected
qt_socios_pj_nulos has constant value "nan" Rejected
qt_socios_pj_suspensos has constant value "nan" Rejected
qt_socios_st_regular is highly correlated with qt_socios_pep (ρ = 1) Rejected
qt_socios_st_suspensa has constant value "1.0" Rejected
qt_ufs_coligados is highly correlated with qt_socios_pj_ativos (ρ = 1) Rejected
sum_faturamento_estimado_coligadas is highly correlated with qt_regioes_coligados (ρ = 0.97948) Rejected
total is highly correlated with qt_funcionarios_12meses (ρ = 0.97438) Rejected
total_filiais_coligados has 540 (97.3%) missing values Missing
tx_crescimento_12meses has 63 (11.4%) zeros Zeros
tx_crescimento_12meses has 458 (82.5%) missing values Missing
tx_crescimento_24meses is highly correlated with min_vl_folha_coligados_gp (ρ = 0.96758) Rejected
tx_rotatividade is highly correlated with qt_art (ρ = 1) Rejected
vl_faturamento_estimado_aux is highly correlated with qt_socios_pj_ativos (ρ = 1) Rejected
vl_faturamento_estimado_grupo_aux is highly correlated with qt_socios_pj_ativos (ρ = 1) Rejected
vl_folha_coligados is highly correlated with vl_faturamento_estimado_grupo_aux (ρ = 0.98018) Rejected
vl_folha_coligados_gp is highly correlated with vl_folha_coligados (ρ = 0.9769) Rejected
vl_frota is highly correlated with total_filiais_coligados (ρ = 1) Rejected
vl_idade_maxima_socios_pj is highly correlated with vl_faturamento_estimado_grupo_aux (ρ = 1) Rejected
vl_idade_media_socios_pj is highly correlated with nu_meses_rescencia (ρ = 1) Rejected
vl_idade_minima_socios_pj is highly correlated with vl_idade_media_socios_pj (ρ = 1) Rejected
vl_potenc_cons_oleo_gas is highly correlated with tx_crescimento_24meses (ρ = 1) Rejected
vl_total_tancagem has constant value "nan" Rejected
vl_total_tancagem_grupo has constant value "nan" Rejected
vl_total_veiculos_antt has constant value "nan" Rejected
vl_total_veiculos_antt_grupo has constant value "nan" Rejected
vl_total_veiculos_leves is highly correlated with total_filiais_coligados (ρ = 1) Rejected
vl_total_veiculos_leves_grupo is highly correlated with vl_idade_maxima_socios_pj (ρ = 1) Rejected
vl_total_veiculos_pesados is highly correlated with vl_potenc_cons_oleo_gas (ρ = 1) Rejected
vl_total_veiculos_pesados_grupo is highly correlated with vl_total_veiculos_leves_grupo (ρ = 0.99451) Rejected

Variables

coligada_mais_antiga_ativa
Numeric

Distinct count62
Unique (%)11.2%
Missing (%)88.8%
Missing (n)493
Infinite (%)0.0%
Infinite (n)0
Mean218.49
Minimum4.0667
Maximum636.6
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4.0667
5-th percentile19.97
Q190.183
Median191.1
Q3325.13
95-th percentile521.64
Maximum636.6
Range632.53
Interquartile range234.95

Descriptive statistics

Standard deviation165.77
Coef of variation0.75873
Kurtosis0.078607
Mean218.49
MAD130.71
Skewness0.88363
Sum13546
Variance27481
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
27.733 2 0.4%
 
187.9 1 0.2%
 
357.53 1 0.2%
 
399.17 1 0.2%
 
54.967 1 0.2%
 
141.27 1 0.2%
 
214.73 1 0.2%
 
249.33 1 0.2%
 
194.3 1 0.2%
 
248.7 1 0.2%
 
Other values (51) 51 9.2%
 
(Missing) 493 88.8%
 

Minimum 5 values

ValueCountFrequency (%) 
4.0667 1 0.2%
 
9.0667 1 0.2%
 
10.167 1 0.2%
 
19.567 1 0.2%
 
27.633 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
636.6 1 0.2%
 
634.17 1 0.2%
 
611.2 1 0.2%
 
521.8 1 0.2%
 
518.67 1 0.2%
 

coligada_mais_antiga_baixada
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

coligada_mais_nova_ativa
Numeric

Distinct count62
Unique (%)11.2%
Missing (%)88.8%
Missing (n)493
Infinite (%)0.0%
Infinite (n)0
Mean121.3
Minimum1.5667
Maximum476.07
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.5667
5-th percentile5.0417
Q124.358
Median91.367
Q3194.32
95-th percentile367.17
Maximum476.07
Range474.5
Interquartile range169.97

Descriptive statistics

Standard deviation117.36
Coef of variation0.96753
Kurtosis1.3438
Mean121.3
MAD91.365
Skewness1.2863
Sum7520.7
Variance13774
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
27.733 2 0.4%
 
4.0667 1 0.2%
 
121.87 1 0.2%
 
1.5667 1 0.2%
 
57.467 1 0.2%
 
214.73 1 0.2%
 
8.3667 1 0.2%
 
194.3 1 0.2%
 
201.2 1 0.2%
 
287.3 1 0.2%
 
Other values (51) 51 9.2%
 
(Missing) 493 88.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1.5667 1 0.2%
 
4.0667 1 0.2%
 
4.6333 1 0.2%
 
4.8667 1 0.2%
 
8.3667 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
476.07 1 0.2%
 
450.07 1 0.2%
 
426.43 1 0.2%
 
368.27 1 0.2%
 
346.37 1 0.2%
 

coligada_mais_nova_baixada
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

de_faixa_faturamento_estimado
Categorical

Distinct count8
Unique (%)1.4%
Missing (%)4.5%
Missing (n)25
DE R$ 81.000,01 A R$ 360.000,00
325
ATE R$ 81.000,00
144
DE R$ 360.000,01 A R$ 1.500.000,00
 
41
Other values (4)
 
20
(Missing)
 
25
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 325 58.6%
 
ATE R$ 81.000,00 144 25.9%
 
DE R$ 360.000,01 A R$ 1.500.000,00 41 7.4%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 16 2.9%
 
SEM INFORMACAO 2 0.4%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 1 0.2%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 1 0.2%
 
(Missing) 25 4.5%
 
Max length38
Mean length26.175
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count10
Unique (%)1.8%
Missing (%)4.5%
Missing (n)25
DE R$ 81.000,01 A R$ 360.000,00
296
ATE R$ 81.000,00
143
DE R$ 360.000,01 A R$ 1.500.000,00
 
58
Other values (6)
 
33
(Missing)
 
25
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 296 53.3%
 
ATE R$ 81.000,00 143 25.8%
 
DE R$ 360.000,01 A R$ 1.500.000,00 58 10.5%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 18 3.2%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 6 1.1%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 5 0.9%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 2 0.4%
 
ACIMA DE 1 BILHAO DE REAIS 1 0.2%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 1 0.2%
 
(Missing) 25 4.5%
 
Max length40
Mean length26.514
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_indicador_telefone
Constant

This variable is constant and should be ignored for analysis

Constant valueBOA

de_natureza_juridica
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
EMPRESARIO INDIVIDUAL
432
SOCIEDADE EMPRESARIA LIMITADA
105
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA
 
15
Other values (3)
 
3
ValueCountFrequency (%) 
EMPRESARIO INDIVIDUAL 432 77.8%
 
SOCIEDADE EMPRESARIA LIMITADA 105 18.9%
 
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA 15 2.7%
 
SOCIEDADE ANONIMA FECHADA 1 0.2%
 
SOCIEDADE EM CONTA DE PARTICIPACAO 1 0.2%
 
SOCIEDADE EMPRESARIA EM NOME COLETIVO 1 0.2%
 
Max length70
Mean length23.897
Min length21
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_nivel_atividade
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)0.7%
Missing (n)4
MEDIA
280
ALTA
153
BAIXA
116
(Missing)
 
4
ValueCountFrequency (%) 
MEDIA 280 50.5%
 
ALTA 153 27.6%
 
BAIXA 116 20.9%
 
MUITO BAIXA 2 0.4%
 
(Missing) 4 0.7%
 
Max length11
Mean length4.7315
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_ramo
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
COMERCIO VAREJISTA
496
BENS DE CONSUMO
 
59
ValueCountFrequency (%) 
COMERCIO VAREJISTA 496 89.4%
 
BENS DE CONSUMO 59 10.6%
 
Max length18
Mean length17.681
Min length15
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_saude_rescencia
Categorical

Distinct count4
Unique (%)0.7%
Missing (%)2.0%
Missing (n)11
ACIMA DE 1 ANO
453
ATE 1 ANO
 
55
SEM INFORMACAO
 
36
(Missing)
 
11
ValueCountFrequency (%) 
ACIMA DE 1 ANO 453 81.6%
 
ATE 1 ANO 55 9.9%
 
SEM INFORMACAO 36 6.5%
 
(Missing) 11 2.0%
 
Max length14
Mean length13.286
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_saude_tributaria
Categorical

Distinct count7
Unique (%)1.3%
Missing (%)2.0%
Missing (n)11
VERDE
167
AZUL
128
AMARELO
113
Other values (3)
136
ValueCountFrequency (%) 
VERDE 167 30.1%
 
AZUL 128 23.1%
 
AMARELO 113 20.4%
 
CINZA 86 15.5%
 
LARANJA 47 8.5%
 
VERMELHO 3 0.5%
 
(Missing) 11 2.0%
 
Max length8
Mean length5.3225
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

dt_situacao
Categorical

Distinct count416
Unique (%)75.0%
Missing (%)0.0%
Missing (n)0
2005-11-03
100
2010-10-26
 
4
2017-03-29
 
3
Other values (413)
448
ValueCountFrequency (%) 
2005-11-03 100 18.0%
 
2010-10-26 4 0.7%
 
2017-03-29 3 0.5%
 
2006-12-02 3 0.5%
 
2017-02-21 3 0.5%
 
2018-08-16 2 0.4%
 
2002-10-12 2 0.4%
 
2018-03-06 2 0.4%
 
2005-08-27 2 0.4%
 
2007-09-20 2 0.4%
 
Other values (406) 432 77.8%
 
Max length10
Mean length10
Min length10
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count392
Unique (%)70.6%
Missing (%)27.0%
Missing (n)150
Infinite (%)0.0%
Infinite (n)0
Mean1130.5
Minimum110.3
Maximum6201.9
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum110.3
5-th percentile401.95
Q1643.07
Median905.94
Q31303.8
95-th percentile2460
Maximum6201.9
Range6091.6
Interquartile range660.75

Descriptive statistics

Standard deviation815.04
Coef of variation0.72093
Kurtosis9.5517
Mean1130.5
MAD537.27
Skewness2.7053
Sum4.5787e+05
Variance6.6429e+05
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
555.9 2 0.4%
 
1316.5 2 0.4%
 
2361.4 2 0.4%
 
949.29 2 0.4%
 
609.88 2 0.4%
 
4640.2 2 0.4%
 
1660.5 2 0.4%
 
946.33 2 0.4%
 
1461.9 2 0.4%
 
2019.4 2 0.4%
 
Other values (381) 385 69.4%
 
(Missing) 150 27.0%
 

Minimum 5 values

ValueCountFrequency (%) 
110.3 1 0.2%
 
268.85 1 0.2%
 
284.92 1 0.2%
 
285.63 1 0.2%
 
305.93 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
6201.9 1 0.2%
 
5049.8 1 0.2%
 
4815.3 1 0.2%
 
4796.7 1 0.2%
 
4655.8 1 0.2%
 

faturamento_est_coligados
Numeric

Distinct count42
Unique (%)7.6%
Missing (%)88.8%
Missing (n)493
Infinite (%)0.0%
Infinite (n)0
Mean2.3987e+07
Minimum61819
Maximum8.222e+08
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819
5-th percentile2.1e+05
Q12.1e+05
Median6.0546e+05
Q31.9855e+06
95-th percentile3.3467e+07
Maximum8.222e+08
Range8.2214e+08
Interquartile range1.7755e+06

Descriptive statistics

Standard deviation1.1919e+08
Coef of variation4.9689
Kurtosis36.805
Mean2.3987e+07
MAD4.1381e+07
Skewness5.9744
Sum1.4872e+09
Variance1.4207e+16
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 14 2.5%
 
4.2e+05 5 0.9%
 
3.7092e+05 3 0.5%
 
5.5637e+05 2 0.4%
 
4.5728e+05 2 0.4%
 
1.1066e+07 1 0.2%
 
6.3e+05 1 0.2%
 
5.811e+06 1 0.2%
 
8.82e+06 1 0.2%
 
1.0929e+07 1 0.2%
 
Other values (31) 31 5.6%
 
(Missing) 493 88.8%
 

Minimum 5 values

ValueCountFrequency (%) 
61819 1 0.2%
 
1.8546e+05 1 0.2%
 
2.0606e+05 1 0.2%
 
2.1e+05 14 2.5%
 
3.7092e+05 3 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
8.222e+08 1 0.2%
 
4.7092e+08 1 0.2%
 
5.1001e+07 1 0.2%
 
3.4646e+07 1 0.2%
 
1.1066e+07 1 0.2%
 

faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation0.97987

fl_antt
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
551
True
 
4
ValueCountFrequency (%) 
False 551 99.3%
 
True 4 0.7%
 

fl_email
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
300
True
255
ValueCountFrequency (%) 
False 300 54.1%
 
True 255 45.9%
 

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_ltda
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_matriz
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
True
519
False
 
36
ValueCountFrequency (%) 
True 519 93.5%
 
False 36 6.5%
 

fl_me
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
553
True
 
2
ValueCountFrequency (%) 
False 553 99.6%
 
True 2 0.4%
 

fl_mei
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
337
True
218
ValueCountFrequency (%) 
False 337 60.7%
 
True 218 39.3%
 

fl_optante_simei
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)18.2%
Missing (n)101
False
316
True
138
(Missing)
101
ValueCountFrequency (%) 
False 316 56.9%
 
True 138 24.9%
 
(Missing) 101 18.2%
 

fl_optante_simples
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)18.2%
Missing (n)101
True
286
False
168
(Missing)
101
ValueCountFrequency (%) 
True 286 51.5%
 
False 168 30.3%
 
(Missing) 101 18.2%
 

fl_passivel_iss
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
442
True
113
ValueCountFrequency (%) 
False 442 79.6%
 
True 113 20.4%
 

fl_rm
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
NAO
311
SIM
244
ValueCountFrequency (%) 
NAO 311 56.0%
 
SIM 244 44.0%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

fl_sa
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
546
True
 
9
ValueCountFrequency (%) 
False 546 98.4%
 
True 9 1.6%
 

fl_simples_irregular
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_spa
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_st_especial
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_telefone
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
True
400
False
155
ValueCountFrequency (%) 
True 400 72.1%
 
False 155 27.9%
 

fl_veiculo
Boolean

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
False
517
True
 
38
ValueCountFrequency (%) 
False 517 93.2%
 
True 38 6.8%
 

grau_instrucao_macro_analfabeto
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

grau_instrucao_macro_desconhecido
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

grau_instrucao_macro_escolaridade_fundamental
Numeric

Distinct count8
Unique (%)1.4%
Missing (%)95.5%
Missing (n)530
Infinite (%)0.0%
Infinite (n)0
Mean3.56
Minimum1
Maximum25
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q33
95-th percentile13.8
Maximum25
Range24
Interquartile range2

Descriptive statistics

Standard deviation5.6057
Coef of variation1.5746
Kurtosis9.1447
Mean3.56
MAD3.3408
Skewness2.9827
Sum89
Variance31.423
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
1 13 2.3%
 
3 4 0.7%
 
2 4 0.7%
 
4 1 0.2%
 
14 1 0.2%
 
25 1 0.2%
 
13 1 0.2%
 
(Missing) 530 95.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 13 2.3%
 
2 4 0.7%
 
3 4 0.7%
 
4 1 0.2%
 
13 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
25 1 0.2%
 
14 1 0.2%
 
13 1 0.2%
 
4 1 0.2%
 
3 4 0.7%
 

grau_instrucao_macro_escolaridade_media
Numeric

Distinct count18
Unique (%)3.2%
Missing (%)84.5%
Missing (n)469
Infinite (%)0.0%
Infinite (n)0
Mean5.3372
Minimum1
Maximum70
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q36
95-th percentile13.75
Maximum70
Range69
Interquartile range5

Descriptive statistics

Standard deviation9.0302
Coef of variation1.6919
Kurtosis32.587
Mean5.3372
MAD4.6644
Skewness5.1245
Sum459
Variance81.544
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 33 5.9%
 
3 9 1.6%
 
2 8 1.4%
 
6 8 1.4%
 
4 6 1.1%
 
5 5 0.9%
 
11 3 0.5%
 
9 3 0.5%
 
7 2 0.4%
 
13 2 0.4%
 
Other values (7) 7 1.3%
 
(Missing) 469 84.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 33 5.9%
 
2 8 1.4%
 
3 9 1.6%
 
4 6 1.1%
 
5 5 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
70 1 0.2%
 
38 1 0.2%
 
24 1 0.2%
 
18 1 0.2%
 
14 1 0.2%
 

grau_instrucao_macro_escolaridade_superior
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)95.9%
Missing (n)532
1
 
17
2
 
4
4
 
1
(Missing)
532
ValueCountFrequency (%) 
1 17 3.1%
 
2 4 0.7%
 
4 1 0.2%
 
3 1 0.2%
 
(Missing) 532 95.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

id
Categorical, Unique

First 5 values
00b5cef5652ca3e33f15cbab7249b9d1dc06c82df26d76d94f94834d2aba3b29
00b79c8f0f8a5ac93fa441f42b1619846dd2aaa5ddf2b3c3c79c599e1202a16d
013ce96aef919fb847b8f0cfc882a1ebad64e291e78ff61a1988ac3d30c0fe39
01f73b5d6d29e955d5f8862698a291a961a3fde5848de6018e6e251a9bd7aeeb
02183ea423d627596a8a243492f07e048d3cb59ea1114d80704dac0d1d35797d
Last 5 values
feec91169df886e0b49f9625deb4fbb8614e0002788d8f88fbdbc3f80d464b28
ff4ad7a26c1ef7ec42bf5ec66888c43203f44bac4e9d532c43affbd9273a724e
ff633fd9711d44def1878bf872343c4c32ca97a3e2c290ab7214d5e6a99cab26
ff94dca46aa53e42898307c53a702f357bb19cedb4b662aff5e1678f015d6637
ffd7c9bf8cb8089dffcceb22e5d84dc2814c5658f27e04cc8b9c69f56f2e94fd

First 5 values

ValueCountFrequency (%) 
00b5cef5652ca3e33f15cbab7249b9d1dc06c82df26d76d94f94834d2aba3b29 1 0.2%
 
00b79c8f0f8a5ac93fa441f42b1619846dd2aaa5ddf2b3c3c79c599e1202a16d 1 0.2%
 
013ce96aef919fb847b8f0cfc882a1ebad64e291e78ff61a1988ac3d30c0fe39 1 0.2%
 
01f73b5d6d29e955d5f8862698a291a961a3fde5848de6018e6e251a9bd7aeeb 1 0.2%
 
02183ea423d627596a8a243492f07e048d3cb59ea1114d80704dac0d1d35797d 1 0.2%
 

Last 5 values

ValueCountFrequency (%) 
ffd7c9bf8cb8089dffcceb22e5d84dc2814c5658f27e04cc8b9c69f56f2e94fd 1 0.2%
 
ff94dca46aa53e42898307c53a702f357bb19cedb4b662aff5e1678f015d6637 1 0.2%
 
ff633fd9711d44def1878bf872343c4c32ca97a3e2c290ab7214d5e6a99cab26 1 0.2%
 
ff4ad7a26c1ef7ec42bf5ec66888c43203f44bac4e9d532c43affbd9273a724e 1 0.2%
 
feec91169df886e0b49f9625deb4fbb8614e0002788d8f88fbdbc3f80d464b28 1 0.2%
 

idade_acima_de_58
Highly correlated

This variable is highly correlated with grau_instrucao_macro_escolaridade_fundamental and should be ignored for analysis

Correlation0.91736

idade_ate_18
Constant

This variable is constant and should be ignored for analysis

Constant value1.0

idade_de_19_a_23
Highly correlated

This variable is highly correlated with idade_acima_de_58 and should be ignored for analysis

Correlation0.94324

idade_de_24_a_28
Numeric

Distinct count9
Unique (%)1.6%
Missing (%)91.7%
Missing (n)509
Infinite (%)0.0%
Infinite (n)0
Mean2.6522
Minimum1
Maximum11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q33
95-th percentile8.75
Maximum11
Range10
Interquartile range2

Descriptive statistics

Standard deviation2.4424
Coef of variation0.9209
Kurtosis3.3625
Mean2.6522
MAD1.7921
Skewness1.9263
Sum122
Variance5.9652
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
1 21 3.8%
 
2 10 1.8%
 
5 4 0.7%
 
3 4 0.7%
 
4 3 0.5%
 
9 2 0.4%
 
8 1 0.2%
 
11 1 0.2%
 
(Missing) 509 91.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 21 3.8%
 
2 10 1.8%
 
3 4 0.7%
 
4 3 0.5%
 
5 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
11 1 0.2%
 
9 2 0.4%
 
8 1 0.2%
 
5 4 0.7%
 
4 3 0.5%
 

idade_de_29_a_33
Highly correlated

This variable is highly correlated with grau_instrucao_macro_escolaridade_media and should be ignored for analysis

Correlation0.92706

idade_de_34_a_38
Numeric

Distinct count8
Unique (%)1.4%
Missing (%)92.4%
Missing (n)513
Infinite (%)0.0%
Infinite (n)0
Mean2.2381
Minimum1
Maximum12
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile5.95
Maximum12
Range11
Interquartile range1

Descriptive statistics

Standard deviation2.5357
Coef of variation1.133
Kurtosis9.4359
Mean2.2381
MAD1.5646
Skewness3.0083
Sum94
Variance6.4297
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
1 25 4.5%
 
2 8 1.4%
 
3 3 0.5%
 
5 2 0.4%
 
12 2 0.4%
 
4 1 0.2%
 
6 1 0.2%
 
(Missing) 513 92.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 25 4.5%
 
2 8 1.4%
 
3 3 0.5%
 
4 1 0.2%
 
5 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
12 2 0.4%
 
6 1 0.2%
 
5 2 0.4%
 
4 1 0.2%
 
3 3 0.5%
 

idade_de_39_a_43
Numeric

Distinct count9
Unique (%)1.6%
Missing (%)94.2%
Missing (n)523
Infinite (%)0.0%
Infinite (n)0
Mean2.2812
Minimum1
Maximum11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile8.9
Maximum11
Range10
Interquartile range1

Descriptive statistics

Standard deviation2.7266
Coef of variation1.1952
Kurtosis4.2763
Mean2.2812
MAD1.8945
Skewness2.2709
Sum73
Variance7.4345
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
1 23 4.1%
 
2 3 0.5%
 
6 1 0.2%
 
5 1 0.2%
 
11 1 0.2%
 
8 1 0.2%
 
10 1 0.2%
 
4 1 0.2%
 
(Missing) 523 94.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 23 4.1%
 
2 3 0.5%
 
4 1 0.2%
 
5 1 0.2%
 
6 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
11 1 0.2%
 
10 1 0.2%
 
8 1 0.2%
 
6 1 0.2%
 
5 1 0.2%
 

idade_de_44_a_48
Categorical

Distinct count5
Unique (%)0.9%
Missing (%)96.2%
Missing (n)534
1
 
16
2
 
3
5
 
1
(Missing)
534
ValueCountFrequency (%) 
1 16 2.9%
 
2 3 0.5%
 
5 1 0.2%
 
3 1 0.2%
 
(Missing) 534 96.2%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

idade_de_49_a_53
Highly correlated

This variable is highly correlated with idade_de_29_a_33 and should be ignored for analysis

Correlation0.94905

idade_de_54_a_58
Highly correlated

This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis

Correlation0.97795

idade_emp_cat
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
1 a 5
157
5 a 10
144
> 20
92
Other values (3)
162
ValueCountFrequency (%) 
1 a 5 157 28.3%
 
5 a 10 144 25.9%
 
> 20 92 16.6%
 
<= 1 56 10.1%
 
10 a 15 55 9.9%
 
15 a 20 51 9.2%
 
Max length7
Mean length5.3748
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

idade_empresa_anos
Numeric

Distinct count522
Unique (%)94.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean10.139
Minimum0.052055
Maximum47.518
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.052055
5-th percentile0.55753
Q12.9247
Median6.7096
Q315.495
95-th percentile30.3
Maximum47.518
Range47.466
Interquartile range12.57

Descriptive statistics

Standard deviation9.6416
Coef of variation0.95092
Kurtosis1.0832
Mean10.139
MAD7.6767
Skewness1.2805
Sum5627.3
Variance92.961
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0.05205479 1.70821918 8.00821918 8.01506849 13.64520548 32.32328767 47.51780822], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
8.011 4 0.7%
 
1.5836 3 0.5%
 
1.6822 3 0.5%
 
11.112 2 0.4%
 
3.9753 2 0.4%
 
2.2301 2 0.4%
 
1.4685 2 0.4%
 
1.5973 2 0.4%
 
10.63 2 0.4%
 
1.1589 2 0.4%
 
Other values (512) 531 95.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0.052055 2 0.4%
 
0.10959 1 0.2%
 
0.12055 1 0.2%
 
0.15068 1 0.2%
 
0.16438 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
47.518 1 0.2%
 
46.762 1 0.2%
 
46.115 1 0.2%
 
43.186 1 0.2%
 
42.726 1 0.2%
 

idade_maxima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis

Correlation1

idade_maxima_socios
Numeric

Distinct count63
Unique (%)11.4%
Missing (%)34.8%
Missing (n)193
Infinite (%)0.0%
Infinite (n)0
Mean42.873
Minimum9
Maximum83
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum9
5-th percentile24
Q132
Median41
Q351
95-th percentile67.95
Maximum83
Range74
Interquartile range19

Descriptive statistics

Standard deviation13.487
Coef of variation0.31457
Kurtosis-0.14837
Mean42.873
MAD10.892
Skewness0.497
Sum15520
Variance181.89
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
29 18 3.2%
 
37 13 2.3%
 
41 12 2.2%
 
34 12 2.2%
 
50 12 2.2%
 
40 11 2.0%
 
38 11 2.0%
 
42 11 2.0%
 
44 11 2.0%
 
49 10 1.8%
 
Other values (52) 241 43.4%
 
(Missing) 193 34.8%
 

Minimum 5 values

ValueCountFrequency (%) 
9 1 0.2%
 
18 2 0.4%
 
20 4 0.7%
 
21 2 0.4%
 
23 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
83 1 0.2%
 
82 1 0.2%
 
79 1 0.2%
 
78 1 0.2%
 
76 2 0.4%
 

idade_media_coligadas
Numeric

Distinct count63
Unique (%)11.4%
Missing (%)88.6%
Missing (n)492
Infinite (%)0.0%
Infinite (n)0
Mean162.95
Minimum4.0667
Maximum484.37
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4.0667
5-th percentile17.647
Q181.2
Median135.47
Q3225.98
95-th percentile373.85
Maximum484.37
Range480.3
Interquartile range144.78

Descriptive statistics

Standard deviation118.43
Coef of variation0.72678
Kurtosis0.26089
Mean162.95
MAD96.124
Skewness0.84605
Sum10266
Variance14026
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
27.733 2 0.4%
 
206.13 1 0.2%
 
125.63 1 0.2%
 
374.47 1 0.2%
 
57.467 1 0.2%
 
147.02 1 0.2%
 
214.73 1 0.2%
 
124.07 1 0.2%
 
172.2 1 0.2%
 
194.3 1 0.2%
 
Other values (52) 52 9.4%
 
(Missing) 492 88.6%
 

Minimum 5 values

ValueCountFrequency (%) 
4.0667 1 0.2%
 
9.0667 1 0.2%
 
10.167 1 0.2%
 
17.433 1 0.2%
 
19.567 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
484.37 1 0.2%
 
476.07 1 0.2%
 
426.43 1 0.2%
 
374.47 1 0.2%
 
368.27 1 0.2%
 

idade_media_coligadas_ativas
Highly correlated

This variable is highly correlated with idade_media_coligadas and should be ignored for analysis

Correlation1

idade_media_coligadas_baixadas
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

idade_media_socios
Highly correlated

This variable is highly correlated with idade_maxima_socios and should be ignored for analysis

Correlation0.96634

idade_minima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis

Correlation1

idade_minima_socios
Highly correlated

This variable is highly correlated with idade_media_socios and should be ignored for analysis

Correlation0.96723

max_faturamento_est_coligados
Highly correlated

This variable is highly correlated with faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.97533

max_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.92088

max_filiais_coligados
Numeric

Distinct count10
Unique (%)1.8%
Missing (%)97.3%
Missing (n)540
Infinite (%)0.0%
Infinite (n)0
Mean9.2
Minimum1
Maximum46
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q310
95-th percentile36.2
Maximum46
Range45
Interquartile range9

Descriptive statistics

Standard deviation13.278
Coef of variation1.4433
Kurtosis3.7864
Mean9.2
MAD9.6267
Skewness2.0589
Sum138
Variance176.31
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 5 0.9%
 
5 2 0.4%
 
3 2 0.4%
 
6 1 0.2%
 
46 1 0.2%
 
2 1 0.2%
 
32 1 0.2%
 
14 1 0.2%
 
17 1 0.2%
 
(Missing) 540 97.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 5 0.9%
 
2 1 0.2%
 
3 2 0.4%
 
5 2 0.4%
 
6 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
46 1 0.2%
 
32 1 0.2%
 
17 1 0.2%
 
14 1 0.2%
 
6 1 0.2%
 

max_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.99882

max_meses_servicos
Numeric

Distinct count87
Unique (%)15.7%
Missing (%)81.8%
Missing (n)454
Infinite (%)0.0%
Infinite (n)0
Mean72.99
Minimum5.8
Maximum309.33
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum5.8
5-th percentile10
Q125.233
Median54.7
Q393.267
95-th percentile198.77
Maximum309.33
Range303.53
Interquartile range68.033

Descriptive statistics

Standard deviation61.443
Coef of variation0.84181
Kurtosis2.3671
Mean72.99
MAD46.916
Skewness1.4883
Sum7372
Variance3775.3
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
89.2 4 0.7%
 
21.133 3 0.5%
 
43.533 2 0.4%
 
23.2 2 0.4%
 
95.233 2 0.4%
 
93.267 2 0.4%
 
49.6 2 0.4%
 
17.133 2 0.4%
 
91.2 2 0.4%
 
81.067 2 0.4%
 
Other values (76) 78 14.1%
 
(Missing) 454 81.8%
 

Minimum 5 values

ValueCountFrequency (%) 
5.8 1 0.2%
 
5.9667 1 0.2%
 
6.9667 1 0.2%
 
9.3667 1 0.2%
 
9.9 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
309.33 1 0.2%
 
253.5 1 0.2%
 
252.43 1 0.2%
 
234.27 1 0.2%
 
200.77 1 0.2%
 

max_meses_servicos_all
Numeric

Distinct count120
Unique (%)21.6%
Missing (%)76.4%
Missing (n)424
Infinite (%)0.0%
Infinite (n)0
Mean103.35
Minimum1.0333
Maximum5015
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.0333
5-th percentile5.8833
Q123.233
Median46.667
Q389.2
95-th percentile196.22
Maximum5015
Range5013.9
Interquartile range65.967

Descriptive statistics

Standard deviation436.36
Coef of variation4.2222
Kurtosis126.24
Mean103.35
MAD98.032
Skewness11.138
Sum13539
Variance1.9041e+05
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
89.2 4 0.7%
 
43.533 2 0.4%
 
17.133 2 0.4%
 
95.233 2 0.4%
 
93.267 2 0.4%
 
23.2 2 0.4%
 
81.067 2 0.4%
 
52.767 2 0.4%
 
28.433 2 0.4%
 
49.6 2 0.4%
 
Other values (109) 109 19.6%
 
(Missing) 424 76.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1.0333 1 0.2%
 
2.0333 1 0.2%
 
3.4333 1 0.2%
 
4 1 0.2%
 
4.6 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
5015 1 0.2%
 
309.33 1 0.2%
 
252.43 1 0.2%
 
234.27 1 0.2%
 
213.4 1 0.2%
 

max_vl_folha_coligados
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.94328

max_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.98304

media_faturamento_est_coligados
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.946

media_faturamento_est_coligados_gp
Numeric

Distinct count40
Unique (%)7.2%
Missing (%)88.8%
Missing (n)493
Infinite (%)0.0%
Infinite (n)0
Mean6.3477e+06
Minimum61819
Maximum2.4072e+08
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819
5-th percentile2.1e+05
Q12.1e+05
Median4.35e+05
Q31.0679e+06
95-th percentile9.3445e+06
Maximum2.4072e+08
Range2.4066e+08
Interquartile range8.579e+05

Descriptive statistics

Standard deviation3.1643e+07
Coef of variation4.985
Kurtosis51.564
Mean6.3477e+06
MAD1.0327e+07
Skewness7.0118
Sum3.9356e+08
Variance1.0013e+15
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 19 3.4%
 
3.7092e+05 3 0.5%
 
9.3e+05 2 0.4%
 
5.5637e+05 2 0.4%
 
2.2864e+05 2 0.4%
 
1.057e+06 1 0.2%
 
61819 1 0.2%
 
5.1516e+05 1 0.2%
 
4.9455e+05 1 0.2%
 
4.2e+05 1 0.2%
 
Other values (29) 29 5.2%
 
(Missing) 493 88.8%
 

Minimum 5 values

ValueCountFrequency (%) 
61819 1 0.2%
 
1.8546e+05 1 0.2%
 
2.0606e+05 1 0.2%
 
2.1e+05 19 3.4%
 
2.2864e+05 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
2.4072e+08 1 0.2%
 
6.8719e+07 1 0.2%
 
2.6555e+07 1 0.2%
 
9.5305e+06 1 0.2%
 
5.811e+06 1 0.2%
 

media_filiais_coligados
Highly correlated

This variable is highly correlated with max_filiais_coligados and should be ignored for analysis

Correlation0.98482

media_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with media_filiais_coligados and should be ignored for analysis

Correlation0.92902

media_meses_servicos
Numeric

Distinct count96
Unique (%)17.3%
Missing (%)81.8%
Missing (n)454
Infinite (%)0.0%
Infinite (n)0
Mean49.929
Minimum5.4067
Maximum228.16
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum5.4067
5-th percentile6.4167
Q122.323
Median41.967
Q365.917
95-th percentile131.69
Maximum228.16
Range222.75
Interquartile range43.594

Descriptive statistics

Standard deviation40.969
Coef of variation0.82054
Kurtosis4.8392
Mean49.929
MAD28.944
Skewness1.9248
Sum5042.8
Variance1678.5
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
23.533 2 0.4%
 
18.133 2 0.4%
 
86.133 2 0.4%
 
23.2 2 0.4%
 
49.6 2 0.4%
 
66.833 2 0.4%
 
25.233 1 0.2%
 
53.967 1 0.2%
 
82.562 1 0.2%
 
36.996 1 0.2%
 
Other values (85) 85 15.3%
 
(Missing) 454 81.8%
 

Minimum 5 values

ValueCountFrequency (%) 
5.4067 1 0.2%
 
5.7167 1 0.2%
 
5.9556 1 0.2%
 
6.15 1 0.2%
 
6.3333 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
228.16 1 0.2%
 
199.77 1 0.2%
 
176.93 1 0.2%
 
148 1 0.2%
 
142.9 1 0.2%
 

media_meses_servicos_all
Highly correlated

This variable is highly correlated with max_meses_servicos_all and should be ignored for analysis

Correlation0.96516

media_vl_folha_coligados
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis

Correlation0.90233

media_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with media_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.99564

meses_ultima_contratacaco
Numeric

Distinct count103
Unique (%)18.6%
Missing (%)76.4%
Missing (n)424
Infinite (%)0.0%
Infinite (n)0
Mean35.059
Minimum2.1667
Maximum153.1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.1667
5-th percentile2.9333
Q18.0333
Median23.2
Q354.667
95-th percentile92.75
Maximum153.1
Range150.93
Interquartile range46.633

Descriptive statistics

Standard deviation31.521
Coef of variation0.89908
Kurtosis1.3051
Mean35.059
MAD25.683
Skewness1.1825
Sum4592.8
Variance993.58
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.9333 6 1.1%
 
6.9667 4 0.7%
 
25.233 3 0.5%
 
22.133 3 0.5%
 
23.2 3 0.5%
 
4.9667 3 0.5%
 
21.133 3 0.5%
 
38.433 2 0.4%
 
3.8333 2 0.4%
 
18.133 2 0.4%
 
Other values (92) 100 18.0%
 
(Missing) 424 76.4%
 

Minimum 5 values

ValueCountFrequency (%) 
2.1667 1 0.2%
 
2.2 1 0.2%
 
2.2333 1 0.2%
 
2.5333 1 0.2%
 
2.9333 6 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
153.1 1 0.2%
 
142.9 1 0.2%
 
112.33 1 0.2%
 
104.03 1 0.2%
 
102.37 1 0.2%
 

min_faturamento_est_coligados
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.94011

min_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis

Correlation0.98577

min_filiais_coligados
Highly correlated

This variable is highly correlated with media_vl_folha_coligados_gp and should be ignored for analysis

Correlation0.91131

min_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.99747

min_meses_servicos
Numeric

Distinct count79
Unique (%)14.2%
Missing (%)81.8%
Missing (n)454
Infinite (%)0.0%
Infinite (n)0
Mean33.616
Minimum2.1667
Maximum192.63
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.1667
5-th percentile2.9333
Q15.9667
Median22.133
Q348.567
95-th percentile104.03
Maximum192.63
Range190.47
Interquartile range42.6

Descriptive statistics

Standard deviation37.411
Coef of variation1.1129
Kurtosis4.0729
Mean33.616
MAD27.724
Skewness1.9104
Sum3395.2
Variance1399.5
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.9333 6 1.1%
 
23.2 4 0.7%
 
6.9667 4 0.7%
 
4.9667 3 0.5%
 
3.8333 2 0.4%
 
61.767 2 0.4%
 
8.0333 2 0.4%
 
49.6 2 0.4%
 
18.133 2 0.4%
 
25.233 2 0.4%
 
Other values (68) 72 13.0%
 
(Missing) 454 81.8%
 

Minimum 5 values

ValueCountFrequency (%) 
2.1667 1 0.2%
 
2.2 1 0.2%
 
2.2333 1 0.2%
 
2.5333 1 0.2%
 
2.9333 6 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
192.63 1 0.2%
 
153.1 1 0.2%
 
148 1 0.2%
 
142.9 1 0.2%
 
117.57 1 0.2%
 

min_meses_servicos_all
Numeric

Distinct count101
Unique (%)18.2%
Missing (%)76.4%
Missing (n)424
Infinite (%)0.0%
Infinite (n)0
Mean13.219
Minimum-0.7
Maximum142.9
Zeros (%)0.9%
Mini histogram

Quantile statistics

Minimum-0.7
5-th percentile0
Q11.0333
Median5.0333
Q317.283
95-th percentile53.367
Maximum142.9
Range143.6
Interquartile range16.25

Descriptive statistics

Standard deviation20.45
Coef of variation1.547
Kurtosis14.699
Mean13.219
MAD13.28
Skewness3.2827
Sum1731.7
Variance418.2
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 8 1.4%
 
0 5 0.9%
 
3.0667 4 0.7%
 
1.0333 3 0.5%
 
2.0333 3 0.5%
 
2.9333 2 0.4%
 
0.23333 2 0.4%
 
4.0667 2 0.4%
 
0.93333 2 0.4%
 
1.9667 2 0.4%
 
Other values (90) 98 17.7%
 
(Missing) 424 76.4%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.7 1 0.2%
 
-0.46667 1 0.2%
 
-0.23333 1 0.2%
 
-0.066667 2 0.4%
 
0 5 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
142.9 1 0.2%
 
104.03 1 0.2%
 
69 1 0.2%
 
64.833 1 0.2%
 
54.733 1 0.2%
 

min_vl_folha_coligados
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis

Correlation0.91156

min_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with min_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.99979

natureza_juridica_macro
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
OUTROS
447
ENTIDADES EMPRESARIAIS
108
ValueCountFrequency (%) 
OUTROS 447 80.5%
 
ENTIDADES EMPRESARIAIS 108 19.5%
 
Max length22
Mean length9.1135
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_divisao
Categorical

Distinct count8
Unique (%)1.4%
Missing (%)0.0%
Missing (n)0
COMERCIO VAREJISTA
496
FABRICACAO DE PRODUTOS ALIMENTICIOS
 
16
FABRICACAO DE MOVEIS
 
9
Other values (5)
 
34
ValueCountFrequency (%) 
COMERCIO VAREJISTA 496 89.4%
 
FABRICACAO DE PRODUTOS ALIMENTICIOS 16 2.9%
 
FABRICACAO DE MOVEIS 9 1.6%
 
FABRICACAO DE PRODUTOS DE MADEIRA 9 1.6%
 
CONFECCAO DE ARTIGOS DO VESTUARIO E ACESSORIOS 9 1.6%
 
FABRICACAO DE PRODUTOS DIVERSOS 8 1.4%
 
MANUTENCAO REPARACAO E INSTALACAO DE MAQUINAS E EQUIPAMENTOS 7 1.3%
 
FABRICACAO DE BEBIDAS 1 0.2%
 
Max length60
Mean length19.942
Min length18
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_meso_regiao
Categorical

Distinct count20
Unique (%)3.6%
Missing (%)11.5%
Missing (n)64
CENTRO AMAZONENSE
78
LESTE POTIGUAR
77
NORTE MARANHENSE
65
Other values (16)
271
(Missing)
64
ValueCountFrequency (%) 
CENTRO AMAZONENSE 78 14.1%
 
LESTE POTIGUAR 77 13.9%
 
NORTE MARANHENSE 65 11.7%
 
CENTRO NORTE PIAUIENSE 55 9.9%
 
OESTE MARANHENSE 36 6.5%
 
LESTE MARANHENSE 25 4.5%
 
CENTRO MARANHENSE 21 3.8%
 
VALE DO ACRE 20 3.6%
 
OESTE POTIGUAR 18 3.2%
 
SUDESTE PIAUIENSE 17 3.1%
 
Other values (9) 79 14.2%
 
(Missing) 64 11.5%
 
Max length22
Mean length14.805
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_micro_regiao
Categorical

Distinct count67
Unique (%)12.1%
Missing (%)11.5%
Missing (n)64
MANAUS
65
NATAL
 
58
AGLOMERACAO URBANA DE SAO LUIS
 
48
Other values (63)
320
(Missing)
 
64
ValueCountFrequency (%) 
MANAUS 65 11.7%
 
NATAL 58 10.5%
 
AGLOMERACAO URBANA DE SAO LUIS 48 8.6%
 
TERESINA 41 7.4%
 
IMPERATRIZ 20 3.6%
 
RIO BRANCO 15 2.7%
 
PINDARE 11 2.0%
 
LITORAL SUL 10 1.8%
 
ALTO MEDIO CANINDE 9 1.6%
 
MEDIO MEARIM 9 1.6%
 
Other values (56) 205 36.9%
 
(Missing) 64 11.5%
 
Max length33
Mean length11.132
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_segmento
Categorical

Distinct count2
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS
496
INDUSTRIAS DE TRANSFORMACAO
 
59
ValueCountFrequency (%) 
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 496 89.4%
 
INDUSTRIAS DE TRANSFORMACAO 59 10.6%
 
Max length58
Mean length54.705
Min length27
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nu_meses_rescencia
Numeric

Distinct count24
Unique (%)4.3%
Missing (%)8.5%
Missing (n)47
Infinite (%)0.0%
Infinite (n)0
Mean24.772
Minimum7
Maximum54
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7
5-th percentile9
Q122
Median23
Q325
95-th percentile48
Maximum54
Range47
Interquartile range3

Descriptive statistics

Standard deviation9.9697
Coef of variation0.40247
Kurtosis1.8006
Mean24.772
MAD6.0577
Skewness1.222
Sum12584
Variance99.395
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
23 124 22.3%
 
22 107 19.3%
 
24 51 9.2%
 
48 35 6.3%
 
25 35 6.3%
 
26 28 5.0%
 
21 22 4.0%
 
27 16 2.9%
 
9 13 2.3%
 
10 13 2.3%
 
Other values (13) 64 11.5%
 
(Missing) 47 8.5%
 

Minimum 5 values

ValueCountFrequency (%) 
7 10 1.8%
 
8 11 2.0%
 
9 13 2.3%
 
10 13 2.3%
 
11 5 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
54 3 0.5%
 
52 1 0.2%
 
50 11 2.0%
 
49 4 0.7%
 
48 35 6.3%
 

percent_func_genero_fem
Numeric

Distinct count31
Unique (%)5.6%
Missing (%)81.8%
Missing (n)454
Infinite (%)0.0%
Infinite (n)0
Mean54.435
Minimum0
Maximum100
Zeros (%)4.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q119.23
Median53.85
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range80.77

Descriptive statistics

Standard deviation38.792
Coef of variation0.71262
Kurtosis-1.4446
Mean54.435
MAD33.768
Skewness-0.15893
Sum5498
Variance1504.8
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
100 32 5.8%
 
0 22 4.0%
 
50 11 2.0%
 
66.67 5 0.9%
 
33.33 4 0.7%
 
60 2 0.4%
 
75 2 0.4%
 
25 1 0.2%
 
62.5 1 0.2%
 
37.5 1 0.2%
 
Other values (20) 20 3.6%
 
(Missing) 454 81.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 22 4.0%
 
4.76 1 0.2%
 
14.29 1 0.2%
 
15.71 1 0.2%
 
19.23 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
100 32 5.8%
 
85.71 1 0.2%
 
80 1 0.2%
 
77.78 1 0.2%
 
75 2 0.4%
 

percent_func_genero_masc
Numeric

Distinct count31
Unique (%)5.6%
Missing (%)81.8%
Missing (n)454
Infinite (%)0.0%
Infinite (n)0
Mean45.565
Minimum0
Maximum100
Zeros (%)5.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median46.15
Q380.77
95-th percentile100
Maximum100
Range100
Interquartile range80.77

Descriptive statistics

Standard deviation38.792
Coef of variation0.85135
Kurtosis-1.4446
Mean45.565
MAD33.768
Skewness0.15893
Sum4602
Variance1504.8
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 32 5.8%
 
100 22 4.0%
 
50 11 2.0%
 
33.33 5 0.9%
 
66.67 4 0.7%
 
40 2 0.4%
 
25 2 0.4%
 
14.29 1 0.2%
 
37.5 1 0.2%
 
62.5 1 0.2%
 
Other values (20) 20 3.6%
 
(Missing) 454 81.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 32 5.8%
 
14.29 1 0.2%
 
20 1 0.2%
 
22.22 1 0.2%
 
25 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
100 22 4.0%
 
95.24 1 0.2%
 
85.71 1 0.2%
 
84.29 1 0.2%
 
80.77 1 0.2%
 

qt_admitidos
Numeric

Distinct count41
Unique (%)7.4%
Missing (%)76.4%
Missing (n)424
Infinite (%)0.0%
Infinite (n)0
Mean14.374
Minimum1
Maximum203
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11.5
Median5
Q313.5
95-th percentile49.5
Maximum203
Range202
Interquartile range12

Descriptive statistics

Standard deviation26.956
Coef of variation1.8753
Kurtosis25.183
Mean14.374
MAD15.13
Skewness4.4816
Sum1883
Variance726.62
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 33 5.9%
 
2 14 2.5%
 
4 12 2.2%
 
6 7 1.3%
 
3 5 0.9%
 
8 5 0.9%
 
13 4 0.7%
 
9 4 0.7%
 
7 4 0.7%
 
10 4 0.7%
 
Other values (30) 39 7.0%
 
(Missing) 424 76.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 33 5.9%
 
2 14 2.5%
 
3 5 0.9%
 
4 12 2.2%
 
5 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
203 1 0.2%
 
164 1 0.2%
 
100 1 0.2%
 
69 1 0.2%
 
65 1 0.2%
 

qt_admitidos_12meses
Numeric

Distinct count12
Unique (%)2.2%
Missing (%)76.4%
Missing (n)424
Infinite (%)0.0%
Infinite (n)0
Mean1.0229
Minimum0
Maximum15
Zeros (%)16.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile5.5
Maximum15
Range15
Interquartile range1

Descriptive statistics

Standard deviation2.3582
Coef of variation2.3054
Kurtosis16.496
Mean1.0229
MAD1.3958
Skewness3.7071
Sum134
Variance5.561
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 89 16.0%
 
1 17 3.1%
 
2 7 1.3%
 
3 6 1.1%
 
4 4 0.7%
 
7 2 0.4%
 
6 2 0.4%
 
14 1 0.2%
 
9 1 0.2%
 
15 1 0.2%
 
(Missing) 424 76.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 89 16.0%
 
1 17 3.1%
 
2 7 1.3%
 
3 6 1.1%
 
4 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
15 1 0.2%
 
14 1 0.2%
 
9 1 0.2%
 
7 2 0.4%
 
6 2 0.4%
 

qt_alteracao_socio_180d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_365d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_90d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_total
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_art
Highly correlated

This variable is highly correlated with qt_admitidos and should be ignored for analysis

Correlation1

qt_coligadas
Highly correlated

This variable is highly correlated with min_filiais_coligados and should be ignored for analysis

Correlation0.96825

qt_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.99748

qt_coligados_agropecuaria
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)88.6%
Missing (n)492
0
 
62
1
 
1
(Missing)
492
ValueCountFrequency (%) 
0 62 11.2%
 
1 1 0.2%
 
(Missing) 492 88.6%
 

qt_coligados_atividade_alto
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_inativo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_medio
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_mt_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_ativo
Numeric

Distinct count13
Unique (%)2.3%
Missing (%)88.6%
Missing (n)492
Infinite (%)0.0%
Infinite (n)0
Mean3.7937
Minimum0
Maximum42
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
Median2
Q33
95-th percentile18.9
Maximum42
Range42
Interquartile range2

Descriptive statistics

Standard deviation7.3048
Coef of variation1.9255
Kurtosis15.99
Mean3.7937
MAD3.7863
Skewness3.9115
Sum239
Variance53.36
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 30 5.4%
 
2 15 2.7%
 
3 6 1.1%
 
5 3 0.5%
 
9 2 0.4%
 
42 1 0.2%
 
0 1 0.2%
 
6 1 0.2%
 
4 1 0.2%
 
20 1 0.2%
 
Other values (2) 2 0.4%
 
(Missing) 492 88.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
1 30 5.4%
 
2 15 2.7%
 
3 6 1.1%
 
4 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
42 1 0.2%
 
33 1 0.2%
 
23 1 0.2%
 
20 1 0.2%
 
9 2 0.4%
 

qt_coligados_baixada
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_ccivil
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

qt_coligados_centro
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.91428

qt_coligados_comercio
Numeric

Distinct count11
Unique (%)2.0%
Missing (%)88.6%
Missing (n)492
Infinite (%)0.0%
Infinite (n)0
Mean2.4444
Minimum0
Maximum42
Zeros (%)3.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile8.6
Maximum42
Range42
Interquartile range2

Descriptive statistics

Standard deviation6.3418
Coef of variation2.5944
Kurtosis26.422
Mean2.4444
MAD2.8889
Skewness4.8797
Sum154
Variance40.219
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 25 4.5%
 
0 21 3.8%
 
2 8 1.4%
 
5 2 0.4%
 
3 2 0.4%
 
42 1 0.2%
 
4 1 0.2%
 
9 1 0.2%
 
20 1 0.2%
 
22 1 0.2%
 
(Missing) 492 88.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 21 3.8%
 
1 25 4.5%
 
2 8 1.4%
 
3 2 0.4%
 
4 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
42 1 0.2%
 
22 1 0.2%
 
20 1 0.2%
 
9 1 0.2%
 
5 2 0.4%
 

qt_coligados_epp
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_exterior
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_inapta
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)88.6%
Missing (n)492
0
 
62
1
 
1
(Missing)
492
ValueCountFrequency (%) 
0 62 11.2%
 
1 1 0.2%
 
(Missing) 492 88.6%
 

qt_coligados_industria
Highly correlated

This variable is highly correlated with qt_coligados_ccivil and should be ignored for analysis

Correlation0.90112

qt_coligados_ltda
Highly correlated

This variable is highly correlated with qt_coligados_centro and should be ignored for analysis

Correlation1

qt_coligados_matriz
Highly correlated

This variable is highly correlated with qt_coligados and should be ignored for analysis

Correlation0.99154

qt_coligados_me
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_mei
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_nordeste
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation0.90069

qt_coligados_norte
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

qt_coligados_nula
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_sa
Highly correlated

This variable is highly correlated with qt_coligados_industria and should be ignored for analysis

Correlation0.98024

qt_coligados_serviço
Highly correlated

This variable is highly correlated with max_vl_folha_coligados and should be ignored for analysis

Correlation0.91346

qt_coligados_sudeste
Highly correlated

This variable is highly correlated with qt_coligados_ltda and should be ignored for analysis

Correlation0.94436

qt_coligados_sul
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_suspensa
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_desligados
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

qt_desligados_12meses
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

qt_ex_funcionarios
Highly correlated

This variable is highly correlated with qt_desligados and should be ignored for analysis

Correlation0.99994

qt_filiais
Highly correlated

This variable is highly correlated with qt_coligados_sa and should be ignored for analysis

Correlation0.9758

qt_funcionarios
Highly correlated

This variable is highly correlated with idade_de_49_a_53 and should be ignored for analysis

Correlation0.93264

qt_funcionarios_12meses
Highly correlated

This variable is highly correlated with qt_funcionarios and should be ignored for analysis

Correlation0.9758

qt_funcionarios_24meses
Highly correlated

This variable is highly correlated with qt_admitidos and should be ignored for analysis

Correlation0.922

qt_funcionarios_coligados
Highly correlated

This variable is highly correlated with qt_filiais and should be ignored for analysis

Correlation0.94954

qt_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis

Correlation0.97194

qt_funcionarios_grupo
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.91578

qt_ramos_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_grupo and should be ignored for analysis

Correlation0.96688

qt_regioes_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.91428

qt_socios
Numeric

Distinct count7
Unique (%)1.3%
Missing (%)26.5%
Missing (n)147
Infinite (%)0.0%
Infinite (n)0
Mean1.2794
Minimum1
Maximum9
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile2
Maximum9
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.65413
Coef of variation0.51127
Kurtosis50.123
Mean1.2794
MAD0.43144
Skewness5.303
Sum522
Variance0.42788
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
1 315 56.8%
 
2 81 14.6%
 
3 9 1.6%
 
5 1 0.2%
 
9 1 0.2%
 
4 1 0.2%
 
(Missing) 147 26.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 315 56.8%
 
2 81 14.6%
 
3 9 1.6%
 
4 1 0.2%
 
5 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
9 1 0.2%
 
5 1 0.2%
 
4 1 0.2%
 
3 9 1.6%
 
2 81 14.6%
 

qt_socios_coligados
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation0.98249

qt_socios_feminino
Boolean

Distinct count3
Unique (%)0.5%
Missing (%)65.8%
Missing (n)365
1
179
2
 
11
(Missing)
365
ValueCountFrequency (%) 
1 179 32.3%
 
2 11 2.0%
 
(Missing) 365 65.8%
 

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

qt_socios_pep
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation1

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation1

qt_socios_pj
Categorical

Distinct count4
Unique (%)0.7%
Missing (%)26.5%
Missing (n)147
0
406
2
 
1
1
 
1
(Missing)
147
ValueCountFrequency (%) 
0 406 73.2%
 
2 1 0.2%
 
1 1 0.2%
 
(Missing) 147 26.5%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_socios_pj_ativos
Highly correlated

This variable is highly correlated with qt_socios_pj and should be ignored for analysis

Correlation1

qt_socios_pj_baixados
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_socios_pj_inaptos
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_socios_pj_nulos
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_socios_pj_suspensos
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation1

qt_socios_st_suspensa
Constant

This variable is constant and should be ignored for analysis

Constant value1.0

qt_ufs_coligados
Highly correlated

This variable is highly correlated with qt_socios_pj_ativos and should be ignored for analysis

Correlation1

setor
Categorical

Distinct count3
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
COMERCIO
496
INDUSTRIA
 
52
SERVIÇO
 
7
ValueCountFrequency (%) 
COMERCIO 496 89.4%
 
INDUSTRIA 52 9.4%
 
SERVIÇO 7 1.3%
 
Max length9
Mean length8.0937
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

sg_uf
Categorical

Distinct count6
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
MA
157
RN
116
PI
103
Other values (3)
179
ValueCountFrequency (%) 
MA 157 28.3%
 
RN 116 20.9%
 
PI 103 18.6%
 
AM 94 16.9%
 
RO 64 11.5%
 
AC 21 3.8%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf_matriz
Categorical

Distinct count7
Unique (%)1.3%
Missing (%)0.0%
Missing (n)0
MA
156
RN
116
PI
103
Other values (4)
180
ValueCountFrequency (%) 
MA 156 28.1%
 
RN 116 20.9%
 
PI 103 18.6%
 
AM 93 16.8%
 
RO 64 11.5%
 
AC 22 4.0%
 
CE 1 0.2%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sum_faturamento_estimado_coligadas
Highly correlated

This variable is highly correlated with qt_regioes_coligados and should be ignored for analysis

Correlation0.97948

total
Highly correlated

This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis

Correlation0.97438

total_filiais_coligados
Numeric

Distinct count12
Unique (%)2.2%
Missing (%)97.3%
Missing (n)540
Infinite (%)0.0%
Infinite (n)0
Mean14.533
Minimum1
Maximum46
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median5
Q325.5
95-th percentile41.8
Maximum46
Range45
Interquartile range24.5

Descriptive statistics

Standard deviation16.322
Coef of variation1.1231
Kurtosis-0.78836
Mean14.533
MAD13.707
Skewness0.87627
Sum218
Variance266.41
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 5 0.9%
 
36 1 0.2%
 
46 1 0.2%
 
2 1 0.2%
 
5 1 0.2%
 
32 1 0.2%
 
19 1 0.2%
 
13 1 0.2%
 
3 1 0.2%
 
40 1 0.2%
 
(Missing) 540 97.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 5 0.9%
 
2 1 0.2%
 
3 1 0.2%
 
5 1 0.2%
 
13 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
46 1 0.2%
 
40 1 0.2%
 
36 1 0.2%
 
32 1 0.2%
 
19 1 0.2%
 

tx_crescimento_12meses
Numeric

Distinct count26
Unique (%)4.7%
Missing (%)82.5%
Missing (n)458
Infinite (%)0.0%
Infinite (n)0
Mean-0.13232
Minimum-100
Maximum200
Zeros (%)11.4%
Mini histogram

Quantile statistics

Minimum-100
5-th percentile-66.905
Q10
Median0
Q30
95-th percentile34
Maximum200
Range300
Interquartile range0

Descriptive statistics

Standard deviation40.324
Coef of variation-304.74
Kurtosis12.558
Mean-0.13232
MAD16.534
Skewness2.3375
Sum-12.835
Variance1626.1
Memory size28.7 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 63 11.4%
 
-16.667 3 0.5%
 
-50 3 0.5%
 
-6.6667 3 0.5%
 
-100 2 0.4%
 
100 2 0.4%
 
14.286 2 0.4%
 
200 2 0.4%
 
12.5 1 0.2%
 
-37.5 1 0.2%
 
Other values (15) 15 2.7%
 
(Missing) 458 82.5%
 

Minimum 5 values

ValueCountFrequency (%) 
-100 2 0.4%
 
-72.727 1 0.2%
 
-71.429 1 0.2%
 
-67.857 1 0.2%
 
-66.667 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
200 2 0.4%
 
100 2 0.4%
 
50 1 0.2%
 
30 1 0.2%
 
25 1 0.2%
 

tx_crescimento_24meses
Highly correlated

This variable is highly correlated with min_vl_folha_coligados_gp and should be ignored for analysis

Correlation0.96758

tx_rotatividade
Highly correlated

This variable is highly correlated with qt_art and should be ignored for analysis

Correlation1

vl_faturamento_estimado_aux
Highly correlated

This variable is highly correlated with qt_socios_pj_ativos and should be ignored for analysis

Correlation1

vl_faturamento_estimado_grupo_aux
Highly correlated

This variable is highly correlated with qt_socios_pj_ativos and should be ignored for analysis

Correlation1

vl_folha_coligados
Highly correlated

This variable is highly correlated with vl_faturamento_estimado_grupo_aux and should be ignored for analysis

Correlation0.98018

vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with vl_folha_coligados and should be ignored for analysis

Correlation0.9769

vl_frota
Highly correlated

This variable is highly correlated with total_filiais_coligados and should be ignored for analysis

Correlation1

vl_idade_maxima_socios_pj
Highly correlated

This variable is highly correlated with vl_faturamento_estimado_grupo_aux and should be ignored for analysis

Correlation1

vl_idade_media_socios_pj
Highly correlated

This variable is highly correlated with nu_meses_rescencia and should be ignored for analysis

Correlation1

vl_idade_minima_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_media_socios_pj and should be ignored for analysis

Correlation1

vl_potenc_cons_oleo_gas
Highly correlated

This variable is highly correlated with tx_crescimento_24meses and should be ignored for analysis

Correlation1

vl_total_tancagem
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_tancagem_grupo
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_antt
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_antt_grupo
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_leves
Highly correlated

This variable is highly correlated with total_filiais_coligados and should be ignored for analysis

Correlation1

vl_total_veiculos_leves_grupo
Highly correlated

This variable is highly correlated with vl_idade_maxima_socios_pj and should be ignored for analysis

Correlation1

vl_total_veiculos_pesados
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation1

vl_total_veiculos_pesados_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_leves_grupo and should be ignored for analysis

Correlation0.99451

Correlations

Missing values

Sample

First rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
0NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTASEM INFORMACAOCINZA2018-03-06379.96NaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaNdabe79bec87c88ae04e869bf6bd321ee5e1893cecf66255be9ea861a9e5841a9NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.646575NaN45.0NaNNaNNaN45.0NaN45.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTASUDOESTE PIAUIENSESAO RAIMUNDO NONATOCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETASNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOPIPINaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
1NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2012-03-291865.61NaNNaNFalseTrueFalseFalseFalseFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN32e5f4e10932153a7ba869cb0386e7e02d49d2461046b866411556d2af150702NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 106.586301NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN47.633333NaNNaNNaNNaNNaNNaNNaN22.427778NaNNaN58.666667NaNNaNNaNNaNNaN3.966667NaNNaNOUTROSCOMERCIO VAREJISTACENTRO MARANHENSEMEDIO MEARIMCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS22.0NaNNaN6.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN6.00.06.040.00.02.0NaNNaN2.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIOMAMANaNNaNNaNNaN-100.00.0210000.01000915.2NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
2NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2010-10-26798.12NaNNaNFalseFalseFalseFalseTrueFalseTrueTrueTrueFalseSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaNa95d6f30bba445bd3d6b0c5b36f865b38ec01d1733609095d359649cfedf15d1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 108.010959NaN54.0NaNNaNNaN54.0NaN54.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTANORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS24.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOMAMANaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
3NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2005-11-03608.47NaNNaNFalseFalseFalseFalseTrueFalseFalseTrueTrueFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN6cb309685cea0b6d2988818792ec2e6fcb2bd02e0afa9e74532d5040fbc933b8NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2020.863014NaN40.0NaNNaNNaN40.0NaN40.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTAOESTE POTIGUARUMARIZALCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS26.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIORNRNNaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
4NaNNaNNaNNaNDE R$ 1.500.000,01 A R$ 4.800.000,00DE R$ 4.800.000,01 A R$ 10.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2005-11-03880.71NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseTrueFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaN11.03.0f72aa7fa6787b0a5a1c88885b6120850df8ee0f71adc251dfe8d321e9e6de7f5NaNNaNNaN4.03.02.04.01.0NaNNaN15 a 2018.726027NaN33.0NaNNaNNaN33.0NaN33.0NaNNaNNaNNaN91.2166.433333NaNNaNNaNNaNNaNNaN39.45476228.986822NaNNaN19.333333NaNNaNNaNNaN19.3333330.233333NaNNaNENTIDADES EMPRESARIAISCOMERCIO VAREJISTALESTE POTIGUARNATALCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS23.085.7114.2943.00.0NaNNaNNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN29.00.028.0314.015.025.0NaNNaN28.0NaNNaN2.0NaN1.0NaNNaN2.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIORNRNNaN14.0NaN-6.666667-44.00.03029140.85872824.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
5NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2012-08-031126.14NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseTrueFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaNf7e2894dce5dbb49662da50c55bcb96cdc3d34188abfe82d54ab6d94e7244d0cNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 106.238356NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN17.133333NaNNaNNaNNaNNaNNaNNaN17.133333NaNNaN34.266667NaNNaNNaNNaNNaN17.133333NaNNaNOUTROSCOMERCIO VAREJISTASUL MARANHENSEGERAIS DE BALSASCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS25.0NaNNaN1.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1.00.01.000.00.01.0NaNNaN0.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIOMAMANaNNaNNaNNaN-100.00.0210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
6NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALALTACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2009-03-02NaNNaNNaNFalseTrueFalseFalseTrueFalseFalseFalseTrueFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNf0c84600cbd2e126ee8314d22816368f33207e723a6ae7ae781582b320c29e4eNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 109.663014NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO AMAZONENSEMANAUSCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS21.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIOAMAMNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
7NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTASEM INFORMACAOCINZA2018-04-30860.88NaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNd0f8bc5c0e71600d303cacebb3e8e6fd9195322b2c1b15940863e2e980bb17a5NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.495890NaN25.0NaNNaNNaN25.0NaN25.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTALESTE POTIGUARNATALCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETASNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIORNRNNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
893.733333NaN93.733333NaNDE R$ 360.000,01 A R$ 1.500.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNSOCIEDADE EMPRESARIA LIMITADAALTACOMERCIO VAREJISTAATE 1 ANOCINZA2017-08-30771.97210000.0210000.0FalseFalseFalseFalseTrueFalseFalseNaNNaNTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaN5.0NaNb9b02480a757c3cc5054d6c01e44df62b22ea1328a874374abd49b7197b3d91cNaNNaN4.01.0NaNNaNNaNNaNNaNNaN1 a 51.16164493.73333334.093.73333393.733333NaN34.093.73333334.0210000.0210000.0NaNNaN5.85.800000NaNNaN210000.0210000.0NaNNaN5.4066674.811111NaNNaN3.833333210000.0210000.0NaNNaN3.8333331.833333NaNNaNENTIDADES EMPRESARIAISCOMERCIO VAREJISTASUL MARANHENSEGERAIS DE BALSASCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS11.060.0040.006.06.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.01.00.00.00.01.00.00.00.01.01.01.005.00.00.0NaNNaN5.01.01.02.01.01.0NaNNaN2.00.0NaNNaNNaNNaNNaN1.0NaN1.0COMERCIOMAMA210000.05.0NaNNaNNaN0.0927288.0927288.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
930.866667NaN30.866667NaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNSOCIEDADE EMPRESARIA LIMITADAMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2013-07-08853.16210000.0210000.0FalseTrueFalseFalseTrueFalseFalseFalseTrueFalseSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN7d58990ba786a3a26617a8afbf814a9919ab34aa09013a559b2c9d45eb439720NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 105.30958930.86666724.030.86666730.866667NaN24.030.86666724.0210000.0210000.0NaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISCOMERCIO VAREJISTACENTRO NORTE PIAUIENSETERESINACOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS23.0NaNNaNNaNNaNNaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.01.00.00.00.00.00.01.00.00.01.00.00.00.00.00.00.00.0NaNNaNNaN0NaNNaNNaNNaNNaNNaN1.01.02.01.0NaN1.0NaN2.00.0NaNNaNNaNNaNNaN1.0NaN1.0COMERCIOPIPI210000.0NaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0

Last rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
545NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAMARELO2009-08-211043.68NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseTrueFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNf1c4e9e123c2fa80339ad2a363ba133e4d936e6137d7b4696a83490dad648200NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 109.191781NaN53.0NaNNaNNaN53.0NaN53.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO AMAZONENSEMANAUSCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS48.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOAMAMNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
546NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTAATE 1 ANOCINZA2017-02-21NaNNaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNFalseNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN1c216b9c297273b5c220ccabba9d5fe11b3429d957b9856e2c6b7b2ebe399a2bNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.682192NaN50.0NaNNaNNaN50.0NaN50.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTASUDOESTE PIAUIENSESAO RAIMUNDO NONATOCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS7.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOPIPINaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
547NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTAACIMA DE 1 ANOLARANJA2009-09-24NaNNaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseTrueFalseNaNNaN1.0NaNNaN5c1f7c821363f80755976616bd3b789c76d3b60021ef846d34c293a3177df7faNaNNaNNaN1.0NaNNaNNaNNaNNaNNaN> 2021.158904NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN86.13333386.133333NaNNaNNaNNaNNaNNaN86.13333323.696296NaNNaN54.066667NaNNaNNaNNaN86.1333332.433333NaNNaNOUTROSCOMERCIO VAREJISTANaNNaNCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS23.0100.00.09.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN8.00.08.001.01.02.0NaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIORORONaN1.0NaN0.0-50.00.0185457.6185457.6NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
548NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2016-12-191065.92NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseTrueFalseNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN0bb480303fa97577b8e25ae2c4ae8a2f04bff4095dc216a8c85dfceac3f5dae6NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.857534NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTANaNNaNCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS19.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIORORONaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
549NaNNaNNaNNaNNaNNaNNaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTASEM INFORMACAOCINZA2018-05-171098.56NaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNFalseNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN3bf88877e71fb1bd4e0ce2e76ca432d788a3fab38078be21d0cbb5633568a470NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.449315NaN37.0NaNNaNNaN37.0NaN37.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTALESTE POTIGUARLITORAL SULCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETASNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIORNRNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
550NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00BOASOCIEDADE EMPRESARIA LIMITADAMEDIABENS DE CONSUMOACIMA DE 1 ANOLARANJA2005-11-031585.53NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN4e2353206c04c6a8c097252c89f6970594f0796676bba5fceed62603f0acd1caNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2027.660274NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISCONFECCAO DE ARTIGOS DO VESTUARIO E ACESSORIOSNORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISINDUSTRIAS DE TRANSFORMACAO23.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNINDUSTRIAMAMANaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
551NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTAATE 1 ANOCINZA2017-03-24552.94NaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN571a7461978f95114944695065e774a38f06528d287740791a21e64d4e897b5dNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.597260NaN40.0NaNNaNNaN40.0NaN40.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTALESTE MARANHENSECHAPADAS DO ALTO ITAPECURUCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS10.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOMAMANaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
552NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2005-11-03NaNNaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN4fbebb5a4ea9d2c5da87f446aff48403f0409e2e8fe381f8bf1e5b47fa426207NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2031.868493NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO NORTE PIAUIENSETERESINACOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS47.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIOPIPINaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
553NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXACOMERCIO VAREJISTAATE 1 ANOCINZA2017-11-08606.29NaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN8bbff0a749bceb9749c5edd90373270ff9109f069ef27c1370dfe5da43375ee4NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.969863NaN34.0NaNNaNNaN34.0NaN34.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTAOESTE MARANHENSEPINDARECOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS9.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOMAMANaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0
554NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2014-10-316201.91NaNNaNFalseFalseFalseFalseTrueFalseTrueTrueTrueFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN970485e6b8abe52d8fb4e0bf060fb6f0f4f8576cb7583d885a8dcac38f506389NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 53.994521NaN45.0NaNNaNNaN45.0NaN45.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO NORTE PIAUIENSETERESINACOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS22.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOPIPINaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaN0